﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using PetaPoco;
namespace ZhongheCms.Models
{
    public partial class GswTblShipLine
    {
        [ResultColumn]
        public GswTblShioRouteLine ShioRouteLine { get; set; }
        [ResultColumn]
        public List<GswTblShioRouteLine>  ShioRouteLines { get; set; }

        public static List<GswTblShipLine> GetShioList(string keywords, int cusid, string fid)
        {
            var sql = "select * from GswTblShipLine where CustomerId=" + cusid + " and FunctionId=" + fid;
            if (!string.IsNullOrEmpty(keywords))
                sql += " and EndPlace like '%" + keywords + "%'";
            sql += " order by Lno";
            var qry = Fetch(sql);
            return qry;

        }
    }
}